package cn.itbeien.entity;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class TradeOrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public TradeOrderExample() {
        oredCriteria = new ArrayList<>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("ORDER_ID like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("ORDER_ID not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andMercNoIsNull() {
            addCriterion("MERC_NO is null");
            return (Criteria) this;
        }

        public Criteria andMercNoIsNotNull() {
            addCriterion("MERC_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMercNoEqualTo(String value) {
            addCriterion("MERC_NO =", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoNotEqualTo(String value) {
            addCriterion("MERC_NO <>", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoGreaterThan(String value) {
            addCriterion("MERC_NO >", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoGreaterThanOrEqualTo(String value) {
            addCriterion("MERC_NO >=", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoLessThan(String value) {
            addCriterion("MERC_NO <", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoLessThanOrEqualTo(String value) {
            addCriterion("MERC_NO <=", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoLike(String value) {
            addCriterion("MERC_NO like", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoNotLike(String value) {
            addCriterion("MERC_NO not like", value, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoIn(List<String> values) {
            addCriterion("MERC_NO in", values, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoNotIn(List<String> values) {
            addCriterion("MERC_NO not in", values, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoBetween(String value1, String value2) {
            addCriterion("MERC_NO between", value1, value2, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercNoNotBetween(String value1, String value2) {
            addCriterion("MERC_NO not between", value1, value2, "mercNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoIsNull() {
            addCriterion("MERC_ORDER_NO is null");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoIsNotNull() {
            addCriterion("MERC_ORDER_NO is not null");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoEqualTo(String value) {
            addCriterion("MERC_ORDER_NO =", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoNotEqualTo(String value) {
            addCriterion("MERC_ORDER_NO <>", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoGreaterThan(String value) {
            addCriterion("MERC_ORDER_NO >", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoGreaterThanOrEqualTo(String value) {
            addCriterion("MERC_ORDER_NO >=", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoLessThan(String value) {
            addCriterion("MERC_ORDER_NO <", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoLessThanOrEqualTo(String value) {
            addCriterion("MERC_ORDER_NO <=", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoLike(String value) {
            addCriterion("MERC_ORDER_NO like", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoNotLike(String value) {
            addCriterion("MERC_ORDER_NO not like", value, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoIn(List<String> values) {
            addCriterion("MERC_ORDER_NO in", values, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoNotIn(List<String> values) {
            addCriterion("MERC_ORDER_NO not in", values, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoBetween(String value1, String value2) {
            addCriterion("MERC_ORDER_NO between", value1, value2, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andMercOrderNoNotBetween(String value1, String value2) {
            addCriterion("MERC_ORDER_NO not between", value1, value2, "mercOrderNo");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNull() {
            addCriterion("TRADE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIsNotNull() {
            addCriterion("TRADE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTradeTypeEqualTo(String value) {
            addCriterion("TRADE_TYPE =", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotEqualTo(String value) {
            addCriterion("TRADE_TYPE <>", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThan(String value) {
            addCriterion("TRADE_TYPE >", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TRADE_TYPE >=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThan(String value) {
            addCriterion("TRADE_TYPE <", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLessThanOrEqualTo(String value) {
            addCriterion("TRADE_TYPE <=", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeLike(String value) {
            addCriterion("TRADE_TYPE like", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotLike(String value) {
            addCriterion("TRADE_TYPE not like", value, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeIn(List<String> values) {
            addCriterion("TRADE_TYPE in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotIn(List<String> values) {
            addCriterion("TRADE_TYPE not in", values, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeBetween(String value1, String value2) {
            addCriterion("TRADE_TYPE between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andTradeTypeNotBetween(String value1, String value2) {
            addCriterion("TRADE_TYPE not between", value1, value2, "tradeType");
            return (Criteria) this;
        }

        public Criteria andSubjectIsNull() {
            addCriterion("SUBJECT is null");
            return (Criteria) this;
        }

        public Criteria andSubjectIsNotNull() {
            addCriterion("SUBJECT is not null");
            return (Criteria) this;
        }

        public Criteria andSubjectEqualTo(String value) {
            addCriterion("SUBJECT =", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotEqualTo(String value) {
            addCriterion("SUBJECT <>", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectGreaterThan(String value) {
            addCriterion("SUBJECT >", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectGreaterThanOrEqualTo(String value) {
            addCriterion("SUBJECT >=", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLessThan(String value) {
            addCriterion("SUBJECT <", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLessThanOrEqualTo(String value) {
            addCriterion("SUBJECT <=", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectLike(String value) {
            addCriterion("SUBJECT like", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotLike(String value) {
            addCriterion("SUBJECT not like", value, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectIn(List<String> values) {
            addCriterion("SUBJECT in", values, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotIn(List<String> values) {
            addCriterion("SUBJECT not in", values, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectBetween(String value1, String value2) {
            addCriterion("SUBJECT between", value1, value2, "subject");
            return (Criteria) this;
        }

        public Criteria andSubjectNotBetween(String value1, String value2) {
            addCriterion("SUBJECT not between", value1, value2, "subject");
            return (Criteria) this;
        }

        public Criteria andBodyIsNull() {
            addCriterion("BODY is null");
            return (Criteria) this;
        }

        public Criteria andBodyIsNotNull() {
            addCriterion("BODY is not null");
            return (Criteria) this;
        }

        public Criteria andBodyEqualTo(String value) {
            addCriterion("BODY =", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyNotEqualTo(String value) {
            addCriterion("BODY <>", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyGreaterThan(String value) {
            addCriterion("BODY >", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyGreaterThanOrEqualTo(String value) {
            addCriterion("BODY >=", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyLessThan(String value) {
            addCriterion("BODY <", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyLessThanOrEqualTo(String value) {
            addCriterion("BODY <=", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyLike(String value) {
            addCriterion("BODY like", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyNotLike(String value) {
            addCriterion("BODY not like", value, "body");
            return (Criteria) this;
        }

        public Criteria andBodyIn(List<String> values) {
            addCriterion("BODY in", values, "body");
            return (Criteria) this;
        }

        public Criteria andBodyNotIn(List<String> values) {
            addCriterion("BODY not in", values, "body");
            return (Criteria) this;
        }

        public Criteria andBodyBetween(String value1, String value2) {
            addCriterion("BODY between", value1, value2, "body");
            return (Criteria) this;
        }

        public Criteria andBodyNotBetween(String value1, String value2) {
            addCriterion("BODY not between", value1, value2, "body");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNull() {
            addCriterion("ORDER_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNotNull() {
            addCriterion("ORDER_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountEqualTo(BigDecimal value) {
            addCriterion("ORDER_AMOUNT =", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotEqualTo(BigDecimal value) {
            addCriterion("ORDER_AMOUNT <>", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThan(BigDecimal value) {
            addCriterion("ORDER_AMOUNT >", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDER_AMOUNT >=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThan(BigDecimal value) {
            addCriterion("ORDER_AMOUNT <", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ORDER_AMOUNT <=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIn(List<BigDecimal> values) {
            addCriterion("ORDER_AMOUNT in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotIn(List<BigDecimal> values) {
            addCriterion("ORDER_AMOUNT not in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDER_AMOUNT between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ORDER_AMOUNT not between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("ORDER_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("ORDER_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(Date value) {
            addCriterion("ORDER_TIME =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(Date value) {
            addCriterion("ORDER_TIME <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(Date value) {
            addCriterion("ORDER_TIME >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("ORDER_TIME >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(Date value) {
            addCriterion("ORDER_TIME <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("ORDER_TIME <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<Date> values) {
            addCriterion("ORDER_TIME in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<Date> values) {
            addCriterion("ORDER_TIME not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(Date value1, Date value2) {
            addCriterion("ORDER_TIME between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("ORDER_TIME not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderIpIsNull() {
            addCriterion("ORDER_IP is null");
            return (Criteria) this;
        }

        public Criteria andOrderIpIsNotNull() {
            addCriterion("ORDER_IP is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIpEqualTo(String value) {
            addCriterion("ORDER_IP =", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpNotEqualTo(String value) {
            addCriterion("ORDER_IP <>", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpGreaterThan(String value) {
            addCriterion("ORDER_IP >", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpGreaterThanOrEqualTo(String value) {
            addCriterion("ORDER_IP >=", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpLessThan(String value) {
            addCriterion("ORDER_IP <", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpLessThanOrEqualTo(String value) {
            addCriterion("ORDER_IP <=", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpLike(String value) {
            addCriterion("ORDER_IP like", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpNotLike(String value) {
            addCriterion("ORDER_IP not like", value, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpIn(List<String> values) {
            addCriterion("ORDER_IP in", values, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpNotIn(List<String> values) {
            addCriterion("ORDER_IP not in", values, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpBetween(String value1, String value2) {
            addCriterion("ORDER_IP between", value1, value2, "orderIp");
            return (Criteria) this;
        }

        public Criteria andOrderIpNotBetween(String value1, String value2) {
            addCriterion("ORDER_IP not between", value1, value2, "orderIp");
            return (Criteria) this;
        }

        public Criteria andReturnUrlIsNull() {
            addCriterion("RETURN_URL is null");
            return (Criteria) this;
        }

        public Criteria andReturnUrlIsNotNull() {
            addCriterion("RETURN_URL is not null");
            return (Criteria) this;
        }

        public Criteria andReturnUrlEqualTo(String value) {
            addCriterion("RETURN_URL =", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlNotEqualTo(String value) {
            addCriterion("RETURN_URL <>", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlGreaterThan(String value) {
            addCriterion("RETURN_URL >", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlGreaterThanOrEqualTo(String value) {
            addCriterion("RETURN_URL >=", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlLessThan(String value) {
            addCriterion("RETURN_URL <", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlLessThanOrEqualTo(String value) {
            addCriterion("RETURN_URL <=", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlLike(String value) {
            addCriterion("RETURN_URL like", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlNotLike(String value) {
            addCriterion("RETURN_URL not like", value, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlIn(List<String> values) {
            addCriterion("RETURN_URL in", values, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlNotIn(List<String> values) {
            addCriterion("RETURN_URL not in", values, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlBetween(String value1, String value2) {
            addCriterion("RETURN_URL between", value1, value2, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andReturnUrlNotBetween(String value1, String value2) {
            addCriterion("RETURN_URL not between", value1, value2, "returnUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlIsNull() {
            addCriterion("NOTIFY_URL is null");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlIsNotNull() {
            addCriterion("NOTIFY_URL is not null");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlEqualTo(String value) {
            addCriterion("NOTIFY_URL =", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlNotEqualTo(String value) {
            addCriterion("NOTIFY_URL <>", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlGreaterThan(String value) {
            addCriterion("NOTIFY_URL >", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlGreaterThanOrEqualTo(String value) {
            addCriterion("NOTIFY_URL >=", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlLessThan(String value) {
            addCriterion("NOTIFY_URL <", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlLessThanOrEqualTo(String value) {
            addCriterion("NOTIFY_URL <=", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlLike(String value) {
            addCriterion("NOTIFY_URL like", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlNotLike(String value) {
            addCriterion("NOTIFY_URL not like", value, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlIn(List<String> values) {
            addCriterion("NOTIFY_URL in", values, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlNotIn(List<String> values) {
            addCriterion("NOTIFY_URL not in", values, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlBetween(String value1, String value2) {
            addCriterion("NOTIFY_URL between", value1, value2, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andNotifyUrlNotBetween(String value1, String value2) {
            addCriterion("NOTIFY_URL not between", value1, value2, "notifyUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlIsNull() {
            addCriterion("REFERER_URL is null");
            return (Criteria) this;
        }

        public Criteria andRefererUrlIsNotNull() {
            addCriterion("REFERER_URL is not null");
            return (Criteria) this;
        }

        public Criteria andRefererUrlEqualTo(String value) {
            addCriterion("REFERER_URL =", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlNotEqualTo(String value) {
            addCriterion("REFERER_URL <>", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlGreaterThan(String value) {
            addCriterion("REFERER_URL >", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlGreaterThanOrEqualTo(String value) {
            addCriterion("REFERER_URL >=", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlLessThan(String value) {
            addCriterion("REFERER_URL <", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlLessThanOrEqualTo(String value) {
            addCriterion("REFERER_URL <=", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlLike(String value) {
            addCriterion("REFERER_URL like", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlNotLike(String value) {
            addCriterion("REFERER_URL not like", value, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlIn(List<String> values) {
            addCriterion("REFERER_URL in", values, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlNotIn(List<String> values) {
            addCriterion("REFERER_URL not in", values, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlBetween(String value1, String value2) {
            addCriterion("REFERER_URL between", value1, value2, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andRefererUrlNotBetween(String value1, String value2) {
            addCriterion("REFERER_URL not between", value1, value2, "refererUrl");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodIsNull() {
            addCriterion("ORDER_PERIOD is null");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodIsNotNull() {
            addCriterion("ORDER_PERIOD is not null");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodEqualTo(Integer value) {
            addCriterion("ORDER_PERIOD =", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodNotEqualTo(Integer value) {
            addCriterion("ORDER_PERIOD <>", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodGreaterThan(Integer value) {
            addCriterion("ORDER_PERIOD >", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodGreaterThanOrEqualTo(Integer value) {
            addCriterion("ORDER_PERIOD >=", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodLessThan(Integer value) {
            addCriterion("ORDER_PERIOD <", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodLessThanOrEqualTo(Integer value) {
            addCriterion("ORDER_PERIOD <=", value, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodIn(List<Integer> values) {
            addCriterion("ORDER_PERIOD in", values, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodNotIn(List<Integer> values) {
            addCriterion("ORDER_PERIOD not in", values, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_PERIOD between", value1, value2, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andOrderPeriodNotBetween(Integer value1, Integer value2) {
            addCriterion("ORDER_PERIOD not between", value1, value2, "orderPeriod");
            return (Criteria) this;
        }

        public Criteria andExpireTimeIsNull() {
            addCriterion("EXPIRE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andExpireTimeIsNotNull() {
            addCriterion("EXPIRE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andExpireTimeEqualTo(Date value) {
            addCriterion("EXPIRE_TIME =", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeNotEqualTo(Date value) {
            addCriterion("EXPIRE_TIME <>", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeGreaterThan(Date value) {
            addCriterion("EXPIRE_TIME >", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("EXPIRE_TIME >=", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeLessThan(Date value) {
            addCriterion("EXPIRE_TIME <", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeLessThanOrEqualTo(Date value) {
            addCriterion("EXPIRE_TIME <=", value, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeIn(List<Date> values) {
            addCriterion("EXPIRE_TIME in", values, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeNotIn(List<Date> values) {
            addCriterion("EXPIRE_TIME not in", values, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeBetween(Date value1, Date value2) {
            addCriterion("EXPIRE_TIME between", value1, value2, "expireTime");
            return (Criteria) this;
        }

        public Criteria andExpireTimeNotBetween(Date value1, Date value2) {
            addCriterion("EXPIRE_TIME not between", value1, value2, "expireTime");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNull() {
            addCriterion("REMARK is null");
            return (Criteria) this;
        }

        public Criteria andRemarkIsNotNull() {
            addCriterion("REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andRemarkEqualTo(String value) {
            addCriterion("REMARK =", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotEqualTo(String value) {
            addCriterion("REMARK <>", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThan(String value) {
            addCriterion("REMARK >", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("REMARK >=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThan(String value) {
            addCriterion("REMARK <", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLessThanOrEqualTo(String value) {
            addCriterion("REMARK <=", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkLike(String value) {
            addCriterion("REMARK like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotLike(String value) {
            addCriterion("REMARK not like", value, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkIn(List<String> values) {
            addCriterion("REMARK in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotIn(List<String> values) {
            addCriterion("REMARK not in", values, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkBetween(String value1, String value2) {
            addCriterion("REMARK between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andRemarkNotBetween(String value1, String value2) {
            addCriterion("REMARK not between", value1, value2, "remark");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNull() {
            addCriterion("CREATE_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIsNotNull() {
            addCriterion("CREATE_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCreateTimeEqualTo(Date value) {
            addCriterion("CREATE_TIME =", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotEqualTo(Date value) {
            addCriterion("CREATE_TIME <>", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThan(Date value) {
            addCriterion("CREATE_TIME >", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME >=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThan(Date value) {
            addCriterion("CREATE_TIME <", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_TIME <=", value, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeIn(List<Date> values) {
            addCriterion("CREATE_TIME in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotIn(List<Date> values) {
            addCriterion("CREATE_TIME not in", values, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andCreateTimeNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_TIME not between", value1, value2, "createTime");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNull() {
            addCriterion("PAY_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNotNull() {
            addCriterion("PAY_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andPayStatusEqualTo(String value) {
            addCriterion("PAY_STATUS =", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotEqualTo(String value) {
            addCriterion("PAY_STATUS <>", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThan(String value) {
            addCriterion("PAY_STATUS >", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThanOrEqualTo(String value) {
            addCriterion("PAY_STATUS >=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThan(String value) {
            addCriterion("PAY_STATUS <", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThanOrEqualTo(String value) {
            addCriterion("PAY_STATUS <=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLike(String value) {
            addCriterion("PAY_STATUS like", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotLike(String value) {
            addCriterion("PAY_STATUS not like", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusIn(List<String> values) {
            addCriterion("PAY_STATUS in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotIn(List<String> values) {
            addCriterion("PAY_STATUS not in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusBetween(String value1, String value2) {
            addCriterion("PAY_STATUS between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotBetween(String value1, String value2) {
            addCriterion("PAY_STATUS not between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andIsRefundIsNull() {
            addCriterion("IS_REFUND is null");
            return (Criteria) this;
        }

        public Criteria andIsRefundIsNotNull() {
            addCriterion("IS_REFUND is not null");
            return (Criteria) this;
        }

        public Criteria andIsRefundEqualTo(String value) {
            addCriterion("IS_REFUND =", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundNotEqualTo(String value) {
            addCriterion("IS_REFUND <>", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundGreaterThan(String value) {
            addCriterion("IS_REFUND >", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundGreaterThanOrEqualTo(String value) {
            addCriterion("IS_REFUND >=", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundLessThan(String value) {
            addCriterion("IS_REFUND <", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundLessThanOrEqualTo(String value) {
            addCriterion("IS_REFUND <=", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundLike(String value) {
            addCriterion("IS_REFUND like", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundNotLike(String value) {
            addCriterion("IS_REFUND not like", value, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundIn(List<String> values) {
            addCriterion("IS_REFUND in", values, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundNotIn(List<String> values) {
            addCriterion("IS_REFUND not in", values, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundBetween(String value1, String value2) {
            addCriterion("IS_REFUND between", value1, value2, "isRefund");
            return (Criteria) this;
        }

        public Criteria andIsRefundNotBetween(String value1, String value2) {
            addCriterion("IS_REFUND not between", value1, value2, "isRefund");
            return (Criteria) this;
        }

        public Criteria andRefundTimesIsNull() {
            addCriterion("REFUND_TIMES is null");
            return (Criteria) this;
        }

        public Criteria andRefundTimesIsNotNull() {
            addCriterion("REFUND_TIMES is not null");
            return (Criteria) this;
        }

        public Criteria andRefundTimesEqualTo(Integer value) {
            addCriterion("REFUND_TIMES =", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesNotEqualTo(Integer value) {
            addCriterion("REFUND_TIMES <>", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesGreaterThan(Integer value) {
            addCriterion("REFUND_TIMES >", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesGreaterThanOrEqualTo(Integer value) {
            addCriterion("REFUND_TIMES >=", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesLessThan(Integer value) {
            addCriterion("REFUND_TIMES <", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesLessThanOrEqualTo(Integer value) {
            addCriterion("REFUND_TIMES <=", value, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesIn(List<Integer> values) {
            addCriterion("REFUND_TIMES in", values, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesNotIn(List<Integer> values) {
            addCriterion("REFUND_TIMES not in", values, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesBetween(Integer value1, Integer value2) {
            addCriterion("REFUND_TIMES between", value1, value2, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andRefundTimesNotBetween(Integer value1, Integer value2) {
            addCriterion("REFUND_TIMES not between", value1, value2, "refundTimes");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountIsNull() {
            addCriterion("SUCCESS_REFUND_AMOUNT is null");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountIsNotNull() {
            addCriterion("SUCCESS_REFUND_AMOUNT is not null");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountEqualTo(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT =", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountNotEqualTo(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT <>", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountGreaterThan(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT >", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT >=", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountLessThan(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT <", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SUCCESS_REFUND_AMOUNT <=", value, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountIn(List<BigDecimal> values) {
            addCriterion("SUCCESS_REFUND_AMOUNT in", values, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountNotIn(List<BigDecimal> values) {
            addCriterion("SUCCESS_REFUND_AMOUNT not in", values, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUCCESS_REFUND_AMOUNT between", value1, value2, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andSuccessRefundAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SUCCESS_REFUND_AMOUNT not between", value1, value2, "successRefundAmount");
            return (Criteria) this;
        }

        public Criteria andTermTypeIsNull() {
            addCriterion("TERM_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andTermTypeIsNotNull() {
            addCriterion("TERM_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andTermTypeEqualTo(String value) {
            addCriterion("TERM_TYPE =", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeNotEqualTo(String value) {
            addCriterion("TERM_TYPE <>", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeGreaterThan(String value) {
            addCriterion("TERM_TYPE >", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeGreaterThanOrEqualTo(String value) {
            addCriterion("TERM_TYPE >=", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeLessThan(String value) {
            addCriterion("TERM_TYPE <", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeLessThanOrEqualTo(String value) {
            addCriterion("TERM_TYPE <=", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeLike(String value) {
            addCriterion("TERM_TYPE like", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeNotLike(String value) {
            addCriterion("TERM_TYPE not like", value, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeIn(List<String> values) {
            addCriterion("TERM_TYPE in", values, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeNotIn(List<String> values) {
            addCriterion("TERM_TYPE not in", values, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeBetween(String value1, String value2) {
            addCriterion("TERM_TYPE between", value1, value2, "termType");
            return (Criteria) this;
        }

        public Criteria andTermTypeNotBetween(String value1, String value2) {
            addCriterion("TERM_TYPE not between", value1, value2, "termType");
            return (Criteria) this;
        }

        public Criteria andSignTypeIsNull() {
            addCriterion("SIGN_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSignTypeIsNotNull() {
            addCriterion("SIGN_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSignTypeEqualTo(String value) {
            addCriterion("SIGN_TYPE =", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeNotEqualTo(String value) {
            addCriterion("SIGN_TYPE <>", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeGreaterThan(String value) {
            addCriterion("SIGN_TYPE >", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeGreaterThanOrEqualTo(String value) {
            addCriterion("SIGN_TYPE >=", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeLessThan(String value) {
            addCriterion("SIGN_TYPE <", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeLessThanOrEqualTo(String value) {
            addCriterion("SIGN_TYPE <=", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeLike(String value) {
            addCriterion("SIGN_TYPE like", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeNotLike(String value) {
            addCriterion("SIGN_TYPE not like", value, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeIn(List<String> values) {
            addCriterion("SIGN_TYPE in", values, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeNotIn(List<String> values) {
            addCriterion("SIGN_TYPE not in", values, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeBetween(String value1, String value2) {
            addCriterion("SIGN_TYPE between", value1, value2, "signType");
            return (Criteria) this;
        }

        public Criteria andSignTypeNotBetween(String value1, String value2) {
            addCriterion("SIGN_TYPE not between", value1, value2, "signType");
            return (Criteria) this;
        }

        public Criteria andCharsetIsNull() {
            addCriterion("CHARSET is null");
            return (Criteria) this;
        }

        public Criteria andCharsetIsNotNull() {
            addCriterion("CHARSET is not null");
            return (Criteria) this;
        }

        public Criteria andCharsetEqualTo(String value) {
            addCriterion("CHARSET =", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetNotEqualTo(String value) {
            addCriterion("CHARSET <>", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetGreaterThan(String value) {
            addCriterion("CHARSET >", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetGreaterThanOrEqualTo(String value) {
            addCriterion("CHARSET >=", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetLessThan(String value) {
            addCriterion("CHARSET <", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetLessThanOrEqualTo(String value) {
            addCriterion("CHARSET <=", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetLike(String value) {
            addCriterion("CHARSET like", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetNotLike(String value) {
            addCriterion("CHARSET not like", value, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetIn(List<String> values) {
            addCriterion("CHARSET in", values, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetNotIn(List<String> values) {
            addCriterion("CHARSET not in", values, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetBetween(String value1, String value2) {
            addCriterion("CHARSET between", value1, value2, "charset");
            return (Criteria) this;
        }

        public Criteria andCharsetNotBetween(String value1, String value2) {
            addCriterion("CHARSET not between", value1, value2, "charset");
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("VERSION is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("VERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(String value) {
            addCriterion("VERSION =", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(String value) {
            addCriterion("VERSION <>", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(String value) {
            addCriterion("VERSION >", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(String value) {
            addCriterion("VERSION >=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(String value) {
            addCriterion("VERSION <", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(String value) {
            addCriterion("VERSION <=", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionLike(String value) {
            addCriterion("VERSION like", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotLike(String value) {
            addCriterion("VERSION not like", value, "version");
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<String> values) {
            addCriterion("VERSION in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<String> values) {
            addCriterion("VERSION not in", values, "version");
            return (Criteria) this;
        }

        public Criteria andVersionBetween(String value1, String value2) {
            addCriterion("VERSION between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(String value1, String value2) {
            addCriterion("VERSION not between", value1, value2, "version");
            return (Criteria) this;
        }

        public Criteria andLocaleIsNull() {
            addCriterion("LOCALE is null");
            return (Criteria) this;
        }

        public Criteria andLocaleIsNotNull() {
            addCriterion("LOCALE is not null");
            return (Criteria) this;
        }

        public Criteria andLocaleEqualTo(String value) {
            addCriterion("LOCALE =", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleNotEqualTo(String value) {
            addCriterion("LOCALE <>", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleGreaterThan(String value) {
            addCriterion("LOCALE >", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleGreaterThanOrEqualTo(String value) {
            addCriterion("LOCALE >=", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleLessThan(String value) {
            addCriterion("LOCALE <", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleLessThanOrEqualTo(String value) {
            addCriterion("LOCALE <=", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleLike(String value) {
            addCriterion("LOCALE like", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleNotLike(String value) {
            addCriterion("LOCALE not like", value, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleIn(List<String> values) {
            addCriterion("LOCALE in", values, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleNotIn(List<String> values) {
            addCriterion("LOCALE not in", values, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleBetween(String value1, String value2) {
            addCriterion("LOCALE between", value1, value2, "locale");
            return (Criteria) this;
        }

        public Criteria andLocaleNotBetween(String value1, String value2) {
            addCriterion("LOCALE not between", value1, value2, "locale");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNull() {
            addCriterion("CURRENCY is null");
            return (Criteria) this;
        }

        public Criteria andCurrencyIsNotNull() {
            addCriterion("CURRENCY is not null");
            return (Criteria) this;
        }

        public Criteria andCurrencyEqualTo(String value) {
            addCriterion("CURRENCY =", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotEqualTo(String value) {
            addCriterion("CURRENCY <>", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThan(String value) {
            addCriterion("CURRENCY >", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyGreaterThanOrEqualTo(String value) {
            addCriterion("CURRENCY >=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThan(String value) {
            addCriterion("CURRENCY <", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLessThanOrEqualTo(String value) {
            addCriterion("CURRENCY <=", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyLike(String value) {
            addCriterion("CURRENCY like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotLike(String value) {
            addCriterion("CURRENCY not like", value, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyIn(List<String> values) {
            addCriterion("CURRENCY in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotIn(List<String> values) {
            addCriterion("CURRENCY not in", values, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyBetween(String value1, String value2) {
            addCriterion("CURRENCY between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andCurrencyNotBetween(String value1, String value2) {
            addCriterion("CURRENCY not between", value1, value2, "currency");
            return (Criteria) this;
        }

        public Criteria andMpOpenidIsNull() {
            addCriterion("MP_OPENID is null");
            return (Criteria) this;
        }

        public Criteria andMpOpenidIsNotNull() {
            addCriterion("MP_OPENID is not null");
            return (Criteria) this;
        }

        public Criteria andMpOpenidEqualTo(String value) {
            addCriterion("MP_OPENID =", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidNotEqualTo(String value) {
            addCriterion("MP_OPENID <>", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidGreaterThan(String value) {
            addCriterion("MP_OPENID >", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidGreaterThanOrEqualTo(String value) {
            addCriterion("MP_OPENID >=", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidLessThan(String value) {
            addCriterion("MP_OPENID <", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidLessThanOrEqualTo(String value) {
            addCriterion("MP_OPENID <=", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidLike(String value) {
            addCriterion("MP_OPENID like", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidNotLike(String value) {
            addCriterion("MP_OPENID not like", value, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidIn(List<String> values) {
            addCriterion("MP_OPENID in", values, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidNotIn(List<String> values) {
            addCriterion("MP_OPENID not in", values, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidBetween(String value1, String value2) {
            addCriterion("MP_OPENID between", value1, value2, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpOpenidNotBetween(String value1, String value2) {
            addCriterion("MP_OPENID not between", value1, value2, "mpOpenid");
            return (Criteria) this;
        }

        public Criteria andMpAppidIsNull() {
            addCriterion("MP_APPID is null");
            return (Criteria) this;
        }

        public Criteria andMpAppidIsNotNull() {
            addCriterion("MP_APPID is not null");
            return (Criteria) this;
        }

        public Criteria andMpAppidEqualTo(String value) {
            addCriterion("MP_APPID =", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidNotEqualTo(String value) {
            addCriterion("MP_APPID <>", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidGreaterThan(String value) {
            addCriterion("MP_APPID >", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidGreaterThanOrEqualTo(String value) {
            addCriterion("MP_APPID >=", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidLessThan(String value) {
            addCriterion("MP_APPID <", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidLessThanOrEqualTo(String value) {
            addCriterion("MP_APPID <=", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidLike(String value) {
            addCriterion("MP_APPID like", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidNotLike(String value) {
            addCriterion("MP_APPID not like", value, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidIn(List<String> values) {
            addCriterion("MP_APPID in", values, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidNotIn(List<String> values) {
            addCriterion("MP_APPID not in", values, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidBetween(String value1, String value2) {
            addCriterion("MP_APPID between", value1, value2, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andMpAppidNotBetween(String value1, String value2) {
            addCriterion("MP_APPID not between", value1, value2, "mpAppid");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeIsNull() {
            addCriterion("INTERFACE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeIsNotNull() {
            addCriterion("INTERFACE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeEqualTo(String value) {
            addCriterion("INTERFACE_CODE =", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeNotEqualTo(String value) {
            addCriterion("INTERFACE_CODE <>", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeGreaterThan(String value) {
            addCriterion("INTERFACE_CODE >", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeGreaterThanOrEqualTo(String value) {
            addCriterion("INTERFACE_CODE >=", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeLessThan(String value) {
            addCriterion("INTERFACE_CODE <", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeLessThanOrEqualTo(String value) {
            addCriterion("INTERFACE_CODE <=", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeLike(String value) {
            addCriterion("INTERFACE_CODE like", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeNotLike(String value) {
            addCriterion("INTERFACE_CODE not like", value, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeIn(List<String> values) {
            addCriterion("INTERFACE_CODE in", values, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeNotIn(List<String> values) {
            addCriterion("INTERFACE_CODE not in", values, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeBetween(String value1, String value2) {
            addCriterion("INTERFACE_CODE between", value1, value2, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andInterfaceCodeNotBetween(String value1, String value2) {
            addCriterion("INTERFACE_CODE not between", value1, value2, "interfaceCode");
            return (Criteria) this;
        }

        public Criteria andFeeValueIsNull() {
            addCriterion("FEE_VALUE is null");
            return (Criteria) this;
        }

        public Criteria andFeeValueIsNotNull() {
            addCriterion("FEE_VALUE is not null");
            return (Criteria) this;
        }

        public Criteria andFeeValueEqualTo(BigDecimal value) {
            addCriterion("FEE_VALUE =", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueNotEqualTo(BigDecimal value) {
            addCriterion("FEE_VALUE <>", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueGreaterThan(BigDecimal value) {
            addCriterion("FEE_VALUE >", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE_VALUE >=", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueLessThan(BigDecimal value) {
            addCriterion("FEE_VALUE <", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE_VALUE <=", value, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueIn(List<BigDecimal> values) {
            addCriterion("FEE_VALUE in", values, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueNotIn(List<BigDecimal> values) {
            addCriterion("FEE_VALUE not in", values, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE_VALUE between", value1, value2, "feeValue");
            return (Criteria) this;
        }

        public Criteria andFeeValueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE_VALUE not between", value1, value2, "feeValue");
            return (Criteria) this;
        }

        public Criteria andIsStaticIsNull() {
            addCriterion("IS_STATIC is null");
            return (Criteria) this;
        }

        public Criteria andIsStaticIsNotNull() {
            addCriterion("IS_STATIC is not null");
            return (Criteria) this;
        }

        public Criteria andIsStaticEqualTo(String value) {
            addCriterion("IS_STATIC =", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticNotEqualTo(String value) {
            addCriterion("IS_STATIC <>", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticGreaterThan(String value) {
            addCriterion("IS_STATIC >", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticGreaterThanOrEqualTo(String value) {
            addCriterion("IS_STATIC >=", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticLessThan(String value) {
            addCriterion("IS_STATIC <", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticLessThanOrEqualTo(String value) {
            addCriterion("IS_STATIC <=", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticLike(String value) {
            addCriterion("IS_STATIC like", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticNotLike(String value) {
            addCriterion("IS_STATIC not like", value, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticIn(List<String> values) {
            addCriterion("IS_STATIC in", values, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticNotIn(List<String> values) {
            addCriterion("IS_STATIC not in", values, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticBetween(String value1, String value2) {
            addCriterion("IS_STATIC between", value1, value2, "isStatic");
            return (Criteria) this;
        }

        public Criteria andIsStaticNotBetween(String value1, String value2) {
            addCriterion("IS_STATIC not between", value1, value2, "isStatic");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNull() {
            addCriterion("CHANNEL_CODE is null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIsNotNull() {
            addCriterion("CHANNEL_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andChannelCodeEqualTo(String value) {
            addCriterion("CHANNEL_CODE =", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotEqualTo(String value) {
            addCriterion("CHANNEL_CODE <>", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThan(String value) {
            addCriterion("CHANNEL_CODE >", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("CHANNEL_CODE >=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThan(String value) {
            addCriterion("CHANNEL_CODE <", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLessThanOrEqualTo(String value) {
            addCriterion("CHANNEL_CODE <=", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeLike(String value) {
            addCriterion("CHANNEL_CODE like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotLike(String value) {
            addCriterion("CHANNEL_CODE not like", value, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeIn(List<String> values) {
            addCriterion("CHANNEL_CODE in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotIn(List<String> values) {
            addCriterion("CHANNEL_CODE not in", values, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeBetween(String value1, String value2) {
            addCriterion("CHANNEL_CODE between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andChannelCodeNotBetween(String value1, String value2) {
            addCriterion("CHANNEL_CODE not between", value1, value2, "channelCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeIsNull() {
            addCriterion("PAYWAY_CODE is null");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeIsNotNull() {
            addCriterion("PAYWAY_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeEqualTo(String value) {
            addCriterion("PAYWAY_CODE =", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeNotEqualTo(String value) {
            addCriterion("PAYWAY_CODE <>", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeGreaterThan(String value) {
            addCriterion("PAYWAY_CODE >", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeGreaterThanOrEqualTo(String value) {
            addCriterion("PAYWAY_CODE >=", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeLessThan(String value) {
            addCriterion("PAYWAY_CODE <", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeLessThanOrEqualTo(String value) {
            addCriterion("PAYWAY_CODE <=", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeLike(String value) {
            addCriterion("PAYWAY_CODE like", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeNotLike(String value) {
            addCriterion("PAYWAY_CODE not like", value, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeIn(List<String> values) {
            addCriterion("PAYWAY_CODE in", values, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeNotIn(List<String> values) {
            addCriterion("PAYWAY_CODE not in", values, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeBetween(String value1, String value2) {
            addCriterion("PAYWAY_CODE between", value1, value2, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andPaywayCodeNotBetween(String value1, String value2) {
            addCriterion("PAYWAY_CODE not between", value1, value2, "paywayCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeIsNull() {
            addCriterion("SCENE_CODE is null");
            return (Criteria) this;
        }

        public Criteria andSceneCodeIsNotNull() {
            addCriterion("SCENE_CODE is not null");
            return (Criteria) this;
        }

        public Criteria andSceneCodeEqualTo(String value) {
            addCriterion("SCENE_CODE =", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeNotEqualTo(String value) {
            addCriterion("SCENE_CODE <>", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeGreaterThan(String value) {
            addCriterion("SCENE_CODE >", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeGreaterThanOrEqualTo(String value) {
            addCriterion("SCENE_CODE >=", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeLessThan(String value) {
            addCriterion("SCENE_CODE <", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeLessThanOrEqualTo(String value) {
            addCriterion("SCENE_CODE <=", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeLike(String value) {
            addCriterion("SCENE_CODE like", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeNotLike(String value) {
            addCriterion("SCENE_CODE not like", value, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeIn(List<String> values) {
            addCriterion("SCENE_CODE in", values, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeNotIn(List<String> values) {
            addCriterion("SCENE_CODE not in", values, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeBetween(String value1, String value2) {
            addCriterion("SCENE_CODE between", value1, value2, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andSceneCodeNotBetween(String value1, String value2) {
            addCriterion("SCENE_CODE not between", value1, value2, "sceneCode");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeIsNull() {
            addCriterion("CALL_BACK_TIME is null");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeIsNotNull() {
            addCriterion("CALL_BACK_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeEqualTo(Date value) {
            addCriterion("CALL_BACK_TIME =", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeNotEqualTo(Date value) {
            addCriterion("CALL_BACK_TIME <>", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeGreaterThan(Date value) {
            addCriterion("CALL_BACK_TIME >", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("CALL_BACK_TIME >=", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeLessThan(Date value) {
            addCriterion("CALL_BACK_TIME <", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeLessThanOrEqualTo(Date value) {
            addCriterion("CALL_BACK_TIME <=", value, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeIn(List<Date> values) {
            addCriterion("CALL_BACK_TIME in", values, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeNotIn(List<Date> values) {
            addCriterion("CALL_BACK_TIME not in", values, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeBetween(Date value1, Date value2) {
            addCriterion("CALL_BACK_TIME between", value1, value2, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andCallBackTimeNotBetween(Date value1, Date value2) {
            addCriterion("CALL_BACK_TIME not between", value1, value2, "callBackTime");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceIsNull() {
            addCriterion("TIME_DIFFERENCE is null");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceIsNotNull() {
            addCriterion("TIME_DIFFERENCE is not null");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceEqualTo(Long value) {
            addCriterion("TIME_DIFFERENCE =", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceNotEqualTo(Long value) {
            addCriterion("TIME_DIFFERENCE <>", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceGreaterThan(Long value) {
            addCriterion("TIME_DIFFERENCE >", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceGreaterThanOrEqualTo(Long value) {
            addCriterion("TIME_DIFFERENCE >=", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceLessThan(Long value) {
            addCriterion("TIME_DIFFERENCE <", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceLessThanOrEqualTo(Long value) {
            addCriterion("TIME_DIFFERENCE <=", value, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceIn(List<Long> values) {
            addCriterion("TIME_DIFFERENCE in", values, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceNotIn(List<Long> values) {
            addCriterion("TIME_DIFFERENCE not in", values, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceBetween(Long value1, Long value2) {
            addCriterion("TIME_DIFFERENCE between", value1, value2, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andTimeDifferenceNotBetween(Long value1, Long value2) {
            addCriterion("TIME_DIFFERENCE not between", value1, value2, "timeDifference");
            return (Criteria) this;
        }

        public Criteria andCostValueIsNull() {
            addCriterion("COST_VALUE is null");
            return (Criteria) this;
        }

        public Criteria andCostValueIsNotNull() {
            addCriterion("COST_VALUE is not null");
            return (Criteria) this;
        }

        public Criteria andCostValueEqualTo(BigDecimal value) {
            addCriterion("COST_VALUE =", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueNotEqualTo(BigDecimal value) {
            addCriterion("COST_VALUE <>", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueGreaterThan(BigDecimal value) {
            addCriterion("COST_VALUE >", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("COST_VALUE >=", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueLessThan(BigDecimal value) {
            addCriterion("COST_VALUE <", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueLessThanOrEqualTo(BigDecimal value) {
            addCriterion("COST_VALUE <=", value, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueIn(List<BigDecimal> values) {
            addCriterion("COST_VALUE in", values, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueNotIn(List<BigDecimal> values) {
            addCriterion("COST_VALUE not in", values, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COST_VALUE between", value1, value2, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostValueNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COST_VALUE not between", value1, value2, "costValue");
            return (Criteria) this;
        }

        public Criteria andCostRatioIsNull() {
            addCriterion("COST_RATIO is null");
            return (Criteria) this;
        }

        public Criteria andCostRatioIsNotNull() {
            addCriterion("COST_RATIO is not null");
            return (Criteria) this;
        }

        public Criteria andCostRatioEqualTo(BigDecimal value) {
            addCriterion("COST_RATIO =", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioNotEqualTo(BigDecimal value) {
            addCriterion("COST_RATIO <>", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioGreaterThan(BigDecimal value) {
            addCriterion("COST_RATIO >", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("COST_RATIO >=", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioLessThan(BigDecimal value) {
            addCriterion("COST_RATIO <", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("COST_RATIO <=", value, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioIn(List<BigDecimal> values) {
            addCriterion("COST_RATIO in", values, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioNotIn(List<BigDecimal> values) {
            addCriterion("COST_RATIO not in", values, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COST_RATIO between", value1, value2, "costRatio");
            return (Criteria) this;
        }

        public Criteria andCostRatioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("COST_RATIO not between", value1, value2, "costRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioIsNull() {
            addCriterion("FEE_RATIO is null");
            return (Criteria) this;
        }

        public Criteria andFeeRatioIsNotNull() {
            addCriterion("FEE_RATIO is not null");
            return (Criteria) this;
        }

        public Criteria andFeeRatioEqualTo(BigDecimal value) {
            addCriterion("FEE_RATIO =", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioNotEqualTo(BigDecimal value) {
            addCriterion("FEE_RATIO <>", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioGreaterThan(BigDecimal value) {
            addCriterion("FEE_RATIO >", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE_RATIO >=", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioLessThan(BigDecimal value) {
            addCriterion("FEE_RATIO <", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioLessThanOrEqualTo(BigDecimal value) {
            addCriterion("FEE_RATIO <=", value, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioIn(List<BigDecimal> values) {
            addCriterion("FEE_RATIO in", values, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioNotIn(List<BigDecimal> values) {
            addCriterion("FEE_RATIO not in", values, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE_RATIO between", value1, value2, "feeRatio");
            return (Criteria) this;
        }

        public Criteria andFeeRatioNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("FEE_RATIO not between", value1, value2, "feeRatio");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {
        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}